CREATE TABLE [dbo].[JOL_Bulletin]
(
[JOL_Bulletin_No] [int] NOT NULL IDENTITY(1, 1),
[JOL_Bulletin_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Bulletin_Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Bulletin_Source] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Bulletin_ClickNumber] [int] NULL,
[JOL_Bulletin_Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Bulletin_AddTime] [datetime] NULL,
[JOL_Bulletin_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Bulletin_UpdateTime] [datetime] NULL,
[JOL_Bulletin_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Bulletin_IsSetTop] [bit] NULL CONSTRAINT [DF__JOL_Bulle__JOL_B__67B44C51] DEFAULT ((0)),
[JOL_Bulletin_SubType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Bulletin_ImageUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Bulletin] ADD CONSTRAINT [PK__JOL_Bulletin__66C02818] PRIMARY KEY CLUSTERED  ([JOL_Bulletin_No]) ON [PRIMARY]
GO
